The COVID-19 has lead to a pandamic, this report is based on Ireland.
This is one of my favorite song from Ed Sheeran. He mentioned the Galway which is a city of Ireland and describes his romantic love with his wife, which arrows my interest of the beautiful city of Ireland. Ireland is an island nation located in Western Europe northwest of the United Kingdom. It’s one of the most beautiful land in the world. I did plan to travel but with the COVID pandemic began, all my plans need to be deferred. This report is mainly about the COVID-19 that happens in Ireland.
COVID-19 is caused by a Coronavirus called SARS-CoV-2. The virus that causes COVID-19 is spreading very easily and sustainablely between people. The disease has since spread worldwide, leading to an ongoing pandemic. Now the official treatment for this is to take vaccinations. This report mainly focuses on the COVID-19 spread in Ireland, which has 4994724 people. This report will introduce the daily new cases and death of COVID-19, and how the speed of taking vaccinations. All the statistics is between 2020/01/22 and 2021/08/27.
The data is from a R package called tidycovid19 where can be download from git with link: https://github.com/joachim-gassen/tidycovid19. And these data is colllected from Our World in Data (https://ourworldindata.org/coronavirus-testing). I filter the Ireland of the whole dataset as my report. There are 40 variables in this data, I cleaned the data only with 7 variables. And all these information can be see in table1.
Another dataset is about vaccinations in Ireland, which records the speed of vaccinations. This data is also from Our World in Data(https://ourworldindata.org/covid-vaccinations). I also choose part of the data and compared the speed of how many people get first dose and total doses in Ireland, there are 6 variables with date, total vaccinations, first and second doses people, population, and I also count the vaccination rate for comparing.
The third dataset is about the different cities of Ireland, which is from Ireland’s Open Data portal(https://data.gov.ie/) and collected by Ordnance Survey Ireland(https://data.gov.ie/dataset/covid19countystatisticshpscireland1?package_type=dataset). This dataset only records the Covid statistics from February 2020 to May 2021, and I am going to explore part of it.
This table includes the date, confirmed cases, new cases, death, new death people and all recovered people.You can search anything you want in this table, like type the date or the month and year. What’s more, you can also type the numbers of cases to check which date has so much cases. It’s a very convenient table for you to measure the Covid impact on Ireland.
This graph draws the daily new cases and new deaths, from the graph we can see that there is an extremely increase since the end of 2020 in December and the new cases got a peak on 2020/01/08 with 8227. Similarly, the number of new death also increases a little in the following days. Moreover, in July of 2021, there is going to be a new pandemic wave of Ireland, since the new cases increases gradually and reach a high position of this year. Compared by the number of new deaths, it seems to under control with lower pressure on hospital and more experience of the government. Or definitely you can guess does the vaccinations work ?
The vaccination has been strongly recommended as one of the effective method to against COVID virus. In Ireland, the spread of vaccination began at the end of 2020, while in January there was the highest increasing then. The speed of getting vaccination is really fast, the blue part is the total vaccinations, the pink part is the first dose vaccination and the green part is the fully doses. The pink line and the green line is getting closer. Until 2021-08-25, the fully vaccination is 3297241 and the total population of Ireland is 4982904. Therefore, the total vaccination rate is 66%. This is in a leading position all over the world.
| CountyName | PopulationCensus16 |
|---|---|
| Dublin | 1347359 |
| Cork | 542868 |
| Galway | 258058 |
| Kildare | 222504 |
| Meath | 195044 |
| Limerick | 194899 |
| Tipperary | 159553 |
| Donegal | 159192 |
| Wexford | 149722 |
| Kerry | 147707 |
The table presents the top 10 cities of Ireland, where the capital city is Dublin with the highest population at 1347359, and followed by the Cork and Galway.
| month | Carlow | Cavan | Clare | Cork | Donegal | Dublin | Galway | Kerry | Kildare | Kilkenny | Laois | Leitrim | Limerick | Longford | Louth | Mayo | Meath | Monaghan | Offaly | Roscommon | Sligo | Tipperary | Waterford | Westmeath | Wexford | Wicklow |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| April | 5.02 % | 6.58 % | 4.1 % | 4.13 % | 6.3 % | 6.57 % | 4.03 % | 3.06 % | 5.41 % | 3.58 % | 4.32 % | 2.62 % | 5.84 % | 4.87 % | 7.11 % | 4.94 % | 5.43 % | 8.18 % | 5.53 % | 3.74 % | 3.55 % | 3.67 % | 4.81 % | 4.38 % | 4.73 % | 3.28 % |
| February | 4.64 % | 6.05 % | 3.87 % | 3.9 % | 5.32 % | 5.65 % | 3.6 % | 2.91 % | 4.42 % | 3.43 % | 3.74 % | 2.31 % | 5.38 % | 3.93 % | 6.53 % | 4.57 % | 4.62 % | 7.82 % | 4.22 % | 3.3 % | 3.33 % | 3.11 % | 4.45 % | 3.59 % | 4.37 % | 2.86 % |
| January | 4.12 % | 5.6 % | 3.58 % | 3.68 % | 4.93 % | 5 % | 3.01 % | 2.76 % | 3.91 % | 3.22 % | 3.18 % | 2.01 % | 4.84 % | 3.3 % | 5.93 % | 4.07 % | 4.1 % | 7.14 % | 3.43 % | 3.07 % | 3.08 % | 2.76 % | 3.93 % | 3.1 % | 3.99 % | 2.59 % |
| March | 4.87 % | 6.32 % | 4.01 % | 4.01 % | 5.78 % | 6.17 % | 3.84 % | 3 % | 4.92 % | 3.52 % | 4.05 % | 2.42 % | 5.63 % | 4.54 % | 6.87 % | 4.77 % | 5.1 % | 7.98 % | 5.11 % | 3.56 % | 3.47 % | 3.43 % | 4.67 % | 4.02 % | 4.63 % | 3.08 % |
| May | 5.08 % | 6.7 % | 4.13 % | 4.19 % | 6.48 % | 6.72 % | 4.07 % | 3.08 % | 5.58 % | 3.61 % | 4.34 % | 2.65 % | 5.92 % | 4.91 % | 7.19 % | 4.96 % | 5.54 % | 8.27 % | 5.6 % | 3.91 % | 3.56 % | 3.73 % | 4.86 % | 4.51 % | 4.78 % | 3.33 % |
This table contains the total 26 cities’ increasing rate in 2021 from January to May. Above all, the highest increasing rate is Monaghan which leads the first place of all month with nearly 8% increasing rate. However, it doesn’t belong to the top10 largest population city in the above table. The city who with second highest increasing rate is Louth, which is also not in the Table1. Reversely, the capital city Dublin gets around 6% increasing rate and the second largest population city Cork only gets 4% around increasing rate. Therefore, the more people doesn’t means the higher increasing rate.
Hasell, J., Mathieu, E., Beltekian, D. et al. A cross-country database of COVID-19 testing. Sci Data 7, 345 (2020) https://ourworldindata.org/coronavirus-testing
Joachim Gassen (2021). tidycovid19: Download, Tidy and Visualize Covid-19 Related Data. R package version 0.0.0.9000. https://github.com/joachim-gassen/tidycovid19
Mathieu, E., Ritchie, H., Ortiz-Ospina, E. et al. A global database of COVID-19 vaccinations. Nat Hum Behav (2021) https://ourworldindata.org/covid-vaccinations
Ordnance Survey Ireland. Covid19CountyStatisticsHPSCIreland (2021) https://data.gov.ie/dataset/covid19countystatisticshpscireland1?package_type=dataset
Wickham et al., (2019). Welcome to the tidyverse. Journal of Open Source Software, 4(43), 1686, https://doi.org/10.21105/joss.01686
Richard Iannone, Joe Cheng and Barret Schloerke (2021). gt: Easily Create Presentation-Ready Display Tables. R package version 0.3.1. https://CRAN.R-project.org/package=gt
Achim Zeileis and Gabor Grothendieck (2005). zoo: S3 Infrastructure for Regular and Irregular Time Series. Journal of Statistical Software, 14(6), 1-27. doi:10.18637/jss.v014.i06
C. Sievert. Interactive Web-Based Data Visualization with R, plotly, and shiny. Chapman and Hall/CRC Florida,2020.
Garrett Grolemund, Hadley Wickham (2011). Dates and Times Made Easy with lubridate. Journal of Statistical Software, 40(3), 1-25. URL https://www.jstatsoft.org/v40/i03/.
Hao Zhu (2021). kableExtra: Construct Complex Table with ‘kable’ and Pipe Syntax. R package version 1.3.4. https://CRAN.R-project.org/package=kableExtra